package com.woniu.mapper;

import com.woniu.domain.Feedback;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.woniu.domain.Feedback;
import com.woniu.vo.RFVo;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author zyy
 * @since 2021-03-09
 */
public interface FeedbackMapper extends BaseMapper<Feedback> {
    @Select("SELECT r.*,f.`status`,f.feedback_id FROM t_resume AS r \n" +
            "INNER JOIN t_feedback AS f\n" +
            "ON r.uid=f.user_id  \n" +
            "INNER JOIN t_user_position AS up\n" +
            "ON f.position_id=up.pid\n"+
            "${ew.customSqlSegment}")
    IPage<RFVo> getRfPage(Page<RFVo> page, QueryWrapper<RFVo> ew);

}
